SR_AREA general lookup/validation table
Some organizations classify issues as product-related, services-related, or other. In this scenario, the SR_AREA general lookup/validation table contains the following issue relation codes.
Note: The code is listed first, followed by the description in parentheses.
■ OTHER (Other)
■ PRODUCTS (Products)
■ SERVICES (Services)
SR_CAT general lookup/validation table
Some organizations classify issues according to category. In this scenario, the SR_CAT general lookup/validation table contains the following category codes.
Note: The code is listed first, followed by the description in parentheses.
■ BILLING (Billing)
■ INCORRECT (Incorrect)
■ MISSING (Missing)
■ NONCURRENT (Noncurrent)
■ NONWORKING (Not working)
■ OTHER (Other)
SR_DEVSTATUS general lookup/validation table
Some organizations use issue resolution codes that require manager approval. In this scenario, the SR_DEVSTATUS general lookup/validation table contains the following issue resolution codes.
Note: The code is listed first, followed by the description in parentheses.
■ APPROVE (Approved)
■ DECLINE (Declined)
■ PENDING (Pending approval)
SR_ENVIRON general lookup/validation table
Some organizations classify issues by the member type of the person reporting the issue. In this scenario, the SR_ENVIRON general lookup/validation table contains the following member type codes.
Note: The code is listed first, followed by the description in parentheses.
■ ASSOCIATE (Associate)
■ FAMILY (Family)
■ FULL (Full)
■ NONMEMBER (Nonmember)
■ SENIOR (Senior)
SR_RECORDEDBY general lookup/validation table
Some organizations have several methods by which they are notified of issues. In this scenario, the SR_RECORDEDBY general lookup/validation table contains the following issue notification method codes.
Note: The code is listed first, followed by the description in parentheses.
■ E-MAIL (E-mail)
■ FAX (Fax)
■ LETTER (Letter)
■ OTHER (Other)
■ PHONE (Phone)
■ WEB (Web)
SR_RES general lookup/validation table
Some organizations specify the current resolution status of issues. In this scenario, the SR_RES general lookup/validation table contains the following issue resolution status codes.
Note: The code is listed first, followed by the description in parentheses.
■ CLOSED (Closed)
■ CONFIRM (Confirm)
■ INPROG (In progress)
■ OPEN (Open)
SR_SRVTYPE general lookup/validation table
Some organizations provide several types of services. In this scenario, the SR_SRVTYPE general lookup/validation table contains the following service type codes.
Note: The code is listed first, followed by the description in parentheses.
■ MEMBERSHIP (Membership)
■ PUBS (Publications)
■ SOFTWARE (Software)
■ TOURS (Tours)
■ VIDEOS (Videos)
SR_SYS general lookup/validation table
Some organizations manage issues by their relation to products and services. In this scenario, the SR_SYS general lookup/validation table contains the following product and service codes.
Note: The code is listed first, followed by the description in parentheses.
■ BOOKS (Books)
■ CARDS (Cards)
■ DVD (DVD video)
■ MAGAZINES (Magazines)
■ MEMBERSHIP (Membership)
■ OTHER (Other)
■ SERVICES (Services)
■ SOFTWARE (Software)
■ TOURS (Tours)
■ VHS (VHS video)
SR_VERSION general lookup/validation table
Some organizations resolve issues within specific departments. In this scenario, the SR_VERSION general lookup/validation table contains the following department codes.
Note: The code is listed first, followed by the description in parentheses.
■ MEMBERSHIP (Membership)
■ SALES (Sales)
■ TOURS (Tours)
■ VOLUNTEER (Volunteer Services)